Apple Reference & Presen…tion Library 1994 January/ARPL-Jan94-Disc2of2-Partner-Edition.iso/Applications/Databases/GQL V3.1 Demo Folder/GQL⁄User/GQL_User.rsrc/STR#_1301.txt

Text File | 1993-07-07 | 636 b | 45 lines

SQL>

SQL>

set linesize %d%s

set numwidth %d%s



select table_name, owner from accessible_tables where (table_type = 'TABLE' or table_type = 'VIEW') and owner like '^creator^' and table_name like '^table^' order by table_name;

select column_name,data_type,nullable,data_length,data_precision,data_scale from accessible_columns where table_name = '^0' and owner = '^creator^' order by column_id;

ERROR

ERROR





create table ^0 (^1);

^0 ^1^2

drop table ^0;

set long %d%s

select count(*) from ^1;

select distinct ^0 from ^1 ;

update ^0 set ^1 where ^2;

insert into ^0 (^1) values (^2);

delete from ^0 where ^2;



UPPER